Functions/Procedures

A procedure or function is a schema object that consists of a set of SQL statements and other PL/SQL constructs, grouped together, stored in the database, and run as a unit to solve a specific problem or perform a set of related tasks.

Procedures and functions are identical except that functions always return a single value to the caller, while procedures do not.

Just simply click to open an object pane for Function. By using the object pane toolbar below, you can create new, edit and delete the selected function/procedure.

Create Function/Procedures

To create a new function/procedure

To create a new function/procedure with the same properties as one of the existing function/procedure has (using drag and drop method)

Apply to: current schema {same connection}
Apply to: different schema {same connection}
  different schema {different connection} (Data Transfer tool will be activated)
  • Select the function/procedure(s) for copying in the object pane.
  • Drag and drop the chosen function/procedure(s) to the target database.
  • Select one of the following options:

    • Copy
    • Cancel

To create a new function/procedure with the same properties as one of the existing function/procedure has

Edit Function/Procedure

To edit the existing function/procedure

Run Function/Procedure

To run a function/procedure in the navigation pane/object pane

To run a function/procedure in the Function/Procedure Designer

Debug Function/Procedure

To debug a function/procedure

To debug a function/procedure in the Function/Procedure Designer

Maintain Function/Procedure

To maintain a function/procedure

Delete Function/Procedure

To delete a function/procedure

Achieve Function/Procedure Information

To achieve a function/procedure information